LEGION Model Builder Help

Pasting data into a graph

You can copy and paste demand data from an external application directly into a data profile. This data must be formatted as one or two rows or columns.

When using this format, the first row or column defines either the time (when demand is to be applied to an instant in time) or the start time (when demand is to applied over an interval of time).

The second row or column specifies the demand (number of Entities) corresponding to each time interval. The following illustration shows the start times for each interval in the first row and the associated demand to be applied to each interval in the second row.

Note: Availability Profiles only require 0 and 1, which represent OFF and ON respectively.

To be pasted successfully, the data must incorporate one of these time formats:

Warning: If the data contains the time format mm:ss, LEGION Model Builder will assume that it is hh:mm and will not generate a warning or error. It is vital that all times specified in the data are contained within your model’s overall run-time.
  • hh:mm:ss (hours, minutes and seconds)
  • hh:mm (hours and minutes)
  • Absolute seconds after midnight (the number of seconds since midnight–00h00m–so that they are correct for your model’s start time). For example, to specify a demand at 08h00 in seconds, you would specify 28,800 seconds after midnight, which is 8 x 3600 seconds per hour.

To paste data into an Arrival, Availability or Event Profile:

  1. Copy the relevant data to be pasted from the external application.
  2. Select Data > Data Profiles.

    The ‘Edit Data Profile’ dialog box is displayed.

  3. Select the Data Profile (Arrival or Event) into which you want to paste the data (you may need to create a new one).
  4. Right-click anywhere in the graph and select Edit > Paste.

    Doing this defines the start time from which the pasted data is applied. If you haven’t selected a start time in the graph, the paste function assumes that the pasted data is to be applied from your model’s start time. Data with times (two row or column format) is always pasted into the graph in the specified time intervals.

    The ‘Paste’ dialog box is also displayed.

  5. Select the correct option from the two choices:
    • The data is in rows
    • The data is in columns

    and click the OK button.

    If the data you are pasting contains any format errors or time errors, a message is displayed describing the problem. You must correct these errors and try to paste the data again.

    If there are no errors, the data is successfully pasted into the graph.